package web.dao;

import java.util.Map;

/**
 * @author orlin
 *
 */
public interface QueryPattern {

	public static final String SELECT = "SELECT ";
	public static final String STAR = "*";
	public static final String FROM = " FROM ";
	public static final String AS = " AS ";
	public static final String WHERE = " WHERE ";
	public static final String AND = " AND ";
	public static final String OR = " OR ";
	public static final Object SPACE = " ";
	public static final String DOT = ".";
	public static final String COMMA = ", ";
	public static final String LBRAKET = "(";
	public static final String RBRAKET = ")";
	public static final String EQUAL = " = ";
	public static final String LESS = " < ";
	public static final String GREAT = " > ";
	public static final String LIKE = " LIKE ";
	public static final String IN = " IN ";
	public static final String BETWEEN = " BETWEEN ";
	public static final String IS = " IS ";
	public static final String NOT = " NOT ";
	public static final String NULL = " NULL ";
	public static final String QUOTE = "'";
	public static final String COLUMN = ":";
	public static final String JOIN = " JOIN ";
	public static final String ORDERBY = " ORDERBY ";
	public static final String ASC = " ASC ";
	public static final String DESC = " DESC ";
	
	public String getNickName();
	
	public String getQueryText();
	
	public String getSelectClause();
	
	public String getFromClause();
	
	public String getWhereClause();
	
	public String getOrderByClause();
	
	public Map<String, Object> getParameters();

}
